UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EXaGuiR0AIfGihUF3FvP6ybL/rVfTl+jESJKVCjzCLE='
WHERE
key_id = '1f0a375a4a6b2dc3702622e30d4bae6495a3a8b42e35f7092d37247ee7fb7389'
AND (
token = 'EXaGuiR0AIfGihUF3FvP6ybL/rVfTl+jESJKVCjzCLE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)