UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A9EZJkoEHj8rHK7E7ICxNs/sc9tcEorf/lAuWA2ZIhg='
WHERE
key_id = '1c1ed1c4cd6017173aa9added7b91b0cb4fd2ce9e3ceca015ca7cebc478becdb'
AND (
token = 'A9EZJkoEHj8rHK7E7ICxNs/sc9tcEorf/lAuWA2ZIhg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)