UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qoTPaXYBjY7GRoRKzbiVOvacGOWmyB9X0ANxHnU/jr0='
WHERE
key_id = 'f2fe763b91f415004468086dd775cc0756b163656d86bc5af3c4e9214a572d5b'
AND (
token = 'qoTPaXYBjY7GRoRKzbiVOvacGOWmyB9X0ANxHnU/jr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)