UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G9BhxlhacFfftQKYlUbgW0T2Xpyw9VDq1kf4hvYht5E='
WHERE
key_id = 'ef778921d58f695bb01fb11d569ce4899b107d82a371325bafdb6073b517d535'
AND (
token = 'G9BhxlhacFfftQKYlUbgW0T2Xpyw9VDq1kf4hvYht5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)