UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R4wBUlzoIkKWTX3czbvb+rqL+N1LJPiBiLkrm4qmV58='
WHERE
key_id = '04563d4265cd7f46dff3aaf20f937d5c2b9cbf0c8221e7dfc8ad593afd9d6218'
AND (
token = 'R4wBUlzoIkKWTX3czbvb+rqL+N1LJPiBiLkrm4qmV58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)