UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UNeCBoSOUgfdHJowR2cRD9U3W6I4uKM9iFh7o0XxOLo='
WHERE
key_id = '96642f55e899d708173d2cfa97f2529986659c52c9f633e99952c4283ecb2882'
AND (
token = 'UNeCBoSOUgfdHJowR2cRD9U3W6I4uKM9iFh7o0XxOLo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)