UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XOUmG0jnX4rXrw6giOtt71BPVN4w+M4UhWj/p2Vh2ww='
WHERE
key_id = 'fc3eb0478315b1eb52a5351494222b4b66bac93a66f0ed46ed3872c7dd8749ec'
AND (
token = 'XOUmG0jnX4rXrw6giOtt71BPVN4w+M4UhWj/p2Vh2ww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)