UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7zTYMSR1pzlRrcCtJTdqj1zf61prYjm4WVsY8Yo0Zlc='
WHERE
key_id = '417189d5f409a44a0904bc2a2465e3788705658efe6dfb62d21fd003a42d6313'
AND (
token = '7zTYMSR1pzlRrcCtJTdqj1zf61prYjm4WVsY8Yo0Zlc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)