UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8pjkD2n5rQBaz5aHWmuC4EiL1v+ZDBss/RB6H8WfRg8='
WHERE
key_id = 'bb6d0c77781a1ab0dae76a20a70745a1aac0502aa380fcea59e3857f0ff0852f'
AND (
token = '8pjkD2n5rQBaz5aHWmuC4EiL1v+ZDBss/RB6H8WfRg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)