UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'It6X/0H3P9oFdkRWVDSjB9DOi7hCFo/3qA4i978GJNk='
WHERE
key_id = 'f773ba6fd5e6b04f455928413b6dac27d5d324b1a7fd29b7f616684ac06cc0a2'
AND (
token = 'It6X/0H3P9oFdkRWVDSjB9DOi7hCFo/3qA4i978GJNk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)