UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xZA4EGov75zGjWshZCaBM5L0RmrsAlTV0xoXEmSxhyU='
WHERE
key_id = 'f44ed909fc4da7ac2a9fe175344af3c23c7a8c47024db50112a85c192b5040b5'
AND (
token = 'xZA4EGov75zGjWshZCaBM5L0RmrsAlTV0xoXEmSxhyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)