UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B5HKA7EyimvSNrTzcQGEd/9q5an2iOP25nFjlhNsCf0='
WHERE
key_id = 'abf19b76f5f816318500bc38bfca9dc16493f000360fc0861ab7c5d1eacdbcf6'
AND (
token = 'B5HKA7EyimvSNrTzcQGEd/9q5an2iOP25nFjlhNsCf0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)