UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lVW53qgK3K83CgIxTYkGfman+jWmQDajGWYVY/QQR2c='
WHERE
key_id = 'e0724b5870c94367da13868b3e977ad96a38f25ab0d2988a30d59d24c7dea0c8'
AND (
token = 'lVW53qgK3K83CgIxTYkGfman+jWmQDajGWYVY/QQR2c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)