UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5iY65oN1YZ6/uOdTWFIudrGadS23bIAsYVcPd2pvTdA='
WHERE
key_id = 'c569961d5f8b1415d3d3ae6896098065c33d7c90f3c86c1f9bdf2d95ada468ca'
AND (
token = '5iY65oN1YZ6/uOdTWFIudrGadS23bIAsYVcPd2pvTdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)