UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P/crdtpZtCRMiDC4FZlqGG3hH6nm+fq0JxyhTwnzKgM='
WHERE
key_id = 'f5bf167c03502a29d7d50646ad4390d0080cd793dce3abe43e5a6a34d62d55e7'
AND (
token = 'P/crdtpZtCRMiDC4FZlqGG3hH6nm+fq0JxyhTwnzKgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)