UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Br1uYaxpUtNndTBzygFS2WIouRn0FIylUpuZqzNiYw='
WHERE
key_id = 'd2724b48afd93a47fcd5878508a7c95cc31f6b105e06773a3ebda5e7377aa6e1'
AND (
token = '0Br1uYaxpUtNndTBzygFS2WIouRn0FIylUpuZqzNiYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)