UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Prxxmfk2h1yGNNgvAuv7fE1sj+sddxKH6uZ7sXcZu4k='
WHERE
key_id = '8c223bb2957eb1cebf11348cadfa8bdfc3e4f9c9416981fdb40aca8e16d4fcd5'
AND (
token = 'Prxxmfk2h1yGNNgvAuv7fE1sj+sddxKH6uZ7sXcZu4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)