UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BbUCAka+ZbcISB3bvghsiyRbIyFNgk90tzFz3+xTMLI='
WHERE
key_id = '1a0c6cb39db0add42e9ee0146d11eb9065f7f181ac4b4b6daad5d54b75aeb028'
AND (
token = 'BbUCAka+ZbcISB3bvghsiyRbIyFNgk90tzFz3+xTMLI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)