UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7idwUDKyHLFLj2HPuZ5mCdjltlunDLDi4Rez6MCnjmA='
WHERE
key_id = '61316153e134bbe291f86b4dc32e7e2d3f6a1316fffeedbff57d0116921c23fe'
AND (
token = '7idwUDKyHLFLj2HPuZ5mCdjltlunDLDi4Rez6MCnjmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)