UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SiMfbJl159Om2UDJshZhHnRbCa9OVxf9pGZvawPuwwM='
WHERE
key_id = '50e3e3c8b7806b204d44191cbb3f08beaee91b3c807acdef5b674db077f21488'
AND (
token = 'SiMfbJl159Om2UDJshZhHnRbCa9OVxf9pGZvawPuwwM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)