UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oC8uIqL7Pa6V8RtfVrhWHi16US5sOTd20XtMRa85/+c='
WHERE
key_id = '0c8da684a51856528181cecc8806890c416775061b4adad4f4f4fb1bbf000913'
AND (
token = 'oC8uIqL7Pa6V8RtfVrhWHi16US5sOTd20XtMRa85/+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)