UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ah2giyVul+pgQ6G01dgrlKQkTFrwT/rAEzlchup1+i8='
WHERE
key_id = 'dd50605a7bf039e9c4a37c78d7c45640b05c361208cdd3def3ef1c3e9c7ee434'
AND (
token = 'Ah2giyVul+pgQ6G01dgrlKQkTFrwT/rAEzlchup1+i8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)