UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j/QJv1wZBALyicc9frR33u+ejBeZwKekOffG5VrftUw='
WHERE
key_id = '09c661e2a6efa425027a430654dd2997478a0e08fbf7e17b8c36f9c78a4f0a48'
AND (
token = 'j/QJv1wZBALyicc9frR33u+ejBeZwKekOffG5VrftUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)