UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u4MgHN9GmKc23tnDP2ZzTI/K+JXZQy+Pk/F82Weiyw8='
WHERE
key_id = 'd83cf5a23fde1eceb6344655488b25d688e55208aef6ec60b3d09b25420b3802'
AND (
token = 'u4MgHN9GmKc23tnDP2ZzTI/K+JXZQy+Pk/F82Weiyw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)