UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aC7rz6xxqr7hdft83SkskUmscxttEl36ujk12Cye3Wo='
WHERE
key_id = 'c53b8fb0dd3d853b88864db856639651f33172cdb4872a074f25f28be1046ddf'
AND (
token = 'aC7rz6xxqr7hdft83SkskUmscxttEl36ujk12Cye3Wo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)