UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PinqzEEgXEBkxQK9xohoOhREhv5Xa3wnmLPuRuDr63M='
WHERE
key_id = 'b7e0ff098e7c382f56aaf7e0f5b9385fd08f6310486f5809acf7a5bcf34f9843'
AND (
token = 'PinqzEEgXEBkxQK9xohoOhREhv5Xa3wnmLPuRuDr63M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)