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