UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+zLmGubsCiIljFEsqPUx3f2bjA8ijWN0NSrPPMh+m4M='
WHERE
key_id = '3a9b7771463b32d22b661e3ca9ba58875747dbc01d30842f7ccb0dc6e8e27fad'
AND (
token = '+zLmGubsCiIljFEsqPUx3f2bjA8ijWN0NSrPPMh+m4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)