UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KtJGU3QH0miXT0n9e5tGswkxTWkxvsnvjg45+A+VTEQ='
WHERE
key_id = '0b0f4d2eb46d0c7eaf5fa9e3a145c5ec23d6341c8063eb643f5101836309ec27'
AND (
token = 'KtJGU3QH0miXT0n9e5tGswkxTWkxvsnvjg45+A+VTEQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)