UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gWtDnPL3t3CSPTu2UYhQqN2mi3uH6HxysIPlHzovsZs='
WHERE
key_id = 'd63f63be8eee52c1c44a4ecc3e23c10ac87601b96f8a39b3041be2ab1236b6dd'
AND (
token = 'gWtDnPL3t3CSPTu2UYhQqN2mi3uH6HxysIPlHzovsZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)