UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lZ8XOQSP7mzSgTJ65/JBpzYgF3O5lPoGL4FWisA9744='
WHERE
key_id = '7af331071186572c4f947ca896684454bba9c39b0928b9c672f3900e36e2bcab'
AND (
token = 'lZ8XOQSP7mzSgTJ65/JBpzYgF3O5lPoGL4FWisA9744='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)