UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '57UQsnrFTcnpb+UX181823htYXZvKHSOnECW8d/WGC0='
WHERE
key_id = 'f77d7586406b9ff7ddffde7334ecb7b9fa707fba4935d3c2d5614941fe4701f1'
AND (
token = '57UQsnrFTcnpb+UX181823htYXZvKHSOnECW8d/WGC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)