UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ZP5hhIkIflkqt8+PPpSRyKoQpnW8aUNV18zixHUgxU='
WHERE
key_id = 'adfe42a7e7b190657b483c4c1b1acc360bb1a955e1262b173b6d24b75b94fe61'
AND (
token = '1ZP5hhIkIflkqt8+PPpSRyKoQpnW8aUNV18zixHUgxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)