UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'izRvAmSIxmzp2oWmV1X9iemKcQcGHKZxODnbbX2msRo='
WHERE
key_id = '192084a2e80642ab721b45a98f1adb39fa9ef266dc241d0d034426d8bf420110'
AND (
token = 'izRvAmSIxmzp2oWmV1X9iemKcQcGHKZxODnbbX2msRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)