UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vF0AKfZQAwmY3fJxmg15FLJvibKw1qghmtulVLRcPpg='
WHERE
key_id = '927c0a75b43d55783ff3c78dc88eee59196acac9a20376641ccdf3f3756bce6d'
AND (
token = 'vF0AKfZQAwmY3fJxmg15FLJvibKw1qghmtulVLRcPpg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)