UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZsJUOXj7wnEz6lh7UHWjM3hZdrbgFsqmZa3mDC94450='
WHERE
key_id = '8da7561ad401e01b48cb09eb2c06f271b9bd7db7863026c8757836205c320d33'
AND (
token = 'ZsJUOXj7wnEz6lh7UHWjM3hZdrbgFsqmZa3mDC94450='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)