UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Lz+tQ+UzlF0EhAsTyNydR2HZifFoVnbMcXmVN3irBs='
WHERE
key_id = 'd15be831ba9192f43823267e26414558de8502bd6097fd7a0581c28b92eec3ba'
AND (
token = '0Lz+tQ+UzlF0EhAsTyNydR2HZifFoVnbMcXmVN3irBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)