UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd3d1v+jRdyEzoM4cvxkh2uMlWFwEewcr5juodl3PMW0='
WHERE
key_id = 'a52a9076ea9acaad0b2f185f6e4f489f88e85acec4cd2b545f90ef2d07335e06'
AND (
token = 'd3d1v+jRdyEzoM4cvxkh2uMlWFwEewcr5juodl3PMW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)